create database Bank
go
use Bank
go


create table BankCard (
   Id                   int                  primary key identity,
   stuName              nvarchar(20)         not null,
   stuNo                nvarchar(20)         not null,
   stuSex               nvarchar(20)         not null,
   IsActived            bit                  not null default 1,
   IsDelete             bit                  not null default 0,
   CreateTime           smalldatetime        not null default getdate(),
   UpdateTime           smalldatetime        not null default getdate()
)
go


insert into BankCard(stuName ,stuNo ,stuSex )values
('托尼','1','男'),
('漫威','2','女'),
('队长','3','男'),
('灭霸','4','女'),
('安东尼','5','男')

select * from BankCard 

